CAREWare 6 Bug saving services and annual review custom fields

Modified on Wed, 13 Mar 2024 11:49 by Kevin Ricciardo — Categorized as: Uncategorized

CAREWare support and documentation has been moved to a new location. For the most updated user guides and documentation for CAREWare click on the link below:

jPROG CAREWare Support Portal


As of build 102, the CAREWare database is missing the year 2021 in the cw_year_rft table. The year value is referenced in several places in CAREWare including services, annual custom records, and HRSA reports. This can cause errors entering services or prevent data entry for custom annual review fields.


To resolve this error, follow these instructions:


1. Open SQL Server Management Studio.
2. Connect to the CAREWare database instance.
Image
3. Click New Query.
Image
4. Paste the following query in the New Query window.


Use cw_data
Insert into cw_year_rft (yer_rpk, yer_active, yer_last_updated)
Values (2021, 1, 1900-01-01)


5. Click Execute.


Once that query completes, data entry can continue for 2021 without error.


Back to CAREWare 6 All CAREWare Documentation